<?php
error_reporting(E_ALL ^ E_NOTICE);

set_time_limit(0);
/*ini_set("memory_limit", "200M");
  mysql_connect("host=localhost dbname=comzs  user=root  password=root")
   or die('Could not connect:'.mysql_last_error());
*/
$db_name="comzs";  
 
$table_name="comzs";  
 
$connection= @mysql_connect("localhost","root","root") or die(mysql_error());  
 
$db= @mysql_select_db($db_name,$connection) or die (mysql_error());  
$stime =  date("Y-m-d",strtotime("-61 day"));
$etime =  date("Y-m-d",strtotime("-1 day"));
 
$logdate =  mysql_query("SELECT DISTINCT dataTime FROM `comzs` where dataTime BETWEEN '$stime' AND '$etime'");

while($everylogdate = mysql_fetch_array($logdate))
{
     //游戏总注册人数
    $loginPersonNum_query = mysql_query("SELECT count(DISTINCT deviceid) FROM comzs where isJailbreak = '0'");

    $loginPersonNum = mysql_fetch_array($loginPersonNum_query);

     //日均活跃人数 
    $activePesonrNum_query = mysql_query("select(SELECT count(DISTINCT deviceid)  FROM comzs where isJailbreak = '0')/(SELECT count( DISTINCT dataTime )FROM comzs)");
    $activePesonrNum = mysql_fetch_array($activePesonrNum_query);

    //日均活跃人次 activePesonrTime 一个人可能多次
    $activePesonrTime_query = mysql_query("select (SELECT count(deviceid)  FROM comzs where isJailbreak = '0' )/(SELECT count( DISTINCT dataTime )FROM comzs)");
    $activePesonrTime = mysql_fetch_array($activePesonrTime_query);

    //日均人均打开次数  //DISTINCT deviceid
    $totalTodayGameTime_query = mysql_query("SELECT '$activePesonrTime[0]'/'$activePesonrNum[0]'");
    $totalTodayGameTime = mysql_fetch_array($totalTodayGameTime_query);
    //日均游戏时间
    $totalDayTotalTime_query = mysql_query("SELECT avg(playTime)  FROM comzs where isJailbreak = '0'");
    $totalDayTotalTime = mysql_fetch_array($totalDayTotalTime_query);

     //日均金钱获得
    $totalDayGetMoney_query = mysql_query("SELECT avg(cashLoot) FROM comzs where isJailbreak = '0'");
    $totalDayGetMoney = mysql_fetch_array($totalDayGetMoney_query);

    //日均IAP金钱获得
    //$totalDayGetIAPMoney_query = mysql_query("SELECT avg(TotalGoldGet) FROM comzs  where isJailbreak = '0'");
    //$totalDayGetIAPMoney = mysql_fetch_array($totalDayGetIAPMoney_query);

    //日均充值

    $totalDayRecharge_query = mysql_query("SELECT avg(cashIap) FROM comzs where isJailbreak = '0'");
    $totalDayRecharge = mysql_fetch_array($totalDayRecharge_query);
    
    //日均消费totalDayUsedMoney

    $totalDayUsedMoney_query = mysql_query("SELECT avg(cashSpend)  FROM  comzs where isJailbreak = '0'");
    $totalDayUsedMoney = mysql_fetch_array($totalDayUsedMoney_query);
     
    //日均注册人数
    $dayLoginPersonNum_query = mysql_query("select(SELECT count(DISTINCT deviceid) FROM comzs where isJailbreak = '0')/(SELECT count( DISTINCT dataTime )FROM comzs where isJailbreak = '0')");

    $dayLoginPersonNum = mysql_fetch_array($dayLoginPersonNum_query);

    //totalDayNewusers 每日新注册 DISTINCT
    $totalDayNewusers_query = mysql_query("SELECT count(DISTINCT deviceid)  FROM  comzs  where firstLogin = '$everylogdate[dataTime]' and  isJailbreak = '0'");
    $totalDayNewusers = mysql_fetch_array($totalDayNewusers_query);

    //DayActivePesonrNum  每日活跃人数  //  日均TodayGameTime 活跃人数 今日的
    $dayActivePesonrNum_query = mysql_query("SELECT count(DISTINCT deviceid)  FROM comzs  where dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0' and dataTime <> firstLogin");
    $dayActivePesonrNum = mysql_fetch_array($dayActivePesonrNum_query);

    //dayActivePesonrTime 每日活跃人次
    $dayActivePesonrTime_query = mysql_query("SELECT sum( appCount ) FROM comzs WHERE isJailbreak = '0' and dataTime ='$everylogdate[dataTime]' and dataTime <> firstLogin");
    $dayActivePesonrTime = mysql_fetch_array($dayActivePesonrTime_query);
      //weekOneLandPesonrNum 过去7日内1次登录用户数
     $weekOneLandPesonrNum_query = mysql_query("  SELECT DISTINCT deviceid, dataTime
        FROM comzs
        WHERE isJailbreak = '0'  and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND date_sub( '$everylogdate[dataTime]', INTERVAL 1
        DAY )
        GROUP BY deviceid
        HAVING count( 1 ) >0
       ");
     $weekOneLandPesonrNum = mysql_num_rows($weekOneLandPesonrNum_query);

     //weekActivePesonrNum   过去7日内2次登录用户数 每周活跃人数  SELECT * FROM comzs   where date_sub( dataTime, INTERVAL 7 DAY ) <= dataTime( '$everylogdate[dataTime]' )
    $weekActivePesonrNum_query = mysql_query("SELECT DISTINCT deviceid, dataTime
        FROM comzs
        WHERE isJailbreak = '0'  and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND date_sub( '$everylogdate[dataTime]', INTERVAL 1
        DAY )
        GROUP BY deviceid
        HAVING count( 1 ) >1
       ");
    //$weekActivePesonrNum_query = mysql_query("SELECT count(DISTINCT deviceid)  FROM  comzs  where dataTime_add(dataTime,interval 2 day)   and date_sub( dataTime, INTERVAL 7 DAY ) <= dataTime( '$everylogdate[dataTime]' )  and  isJailbreak = '0'");
    $weekActivePesonrNum = mysql_num_rows($weekActivePesonrNum_query);

    //weekLoyalPesonrNum  过去7日内3次登录用户数 每周忠诚用户人数
    $weekLoyalPesonrNum_query = mysql_query("SELECT DISTINCT deviceid, dataTime
        FROM comzs
        WHERE isJailbreak = '0'  and   dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND date_sub( '$everylogdate[dataTime]', INTERVAL 1
        DAY )
        GROUP BY deviceid
        HAVING count( 1 ) >2
        ");
   $weekLoyalPesonrNum = mysql_num_rows($weekLoyalPesonrNum_query);

    //weekCorePesonrNum   过去7日内4次用户数 每周核心用户人数
    $weekCorePesonrNum_query = mysql_query("SELECT DISTINCT deviceid, dataTime
        FROM comzs
        WHERE isJailbreak = '0'  and   dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND date_sub( '$everylogdate[dataTime]', INTERVAL 1
        DAY )
        GROUP BY deviceid
        HAVING count( 1 ) >3
        ");
    $weekCorePesonrNum = mysql_num_rows($weekCorePesonrNum_query);

    // 挂网等雇佣用户数 hirePesonrNum
    //$hirePesonrNum_query = mysql_query("SELECT count(DISTINCT deviceid)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and hireoutselftimes >0 and  isJailbreak = '0'");
   // $hirePesonrNum = mysql_fetch_array($hirePesonrNum_query);

    //今日均人均游戏时间
    $dayTotalTime_query = mysql_query("select (SELECT sum(playTime)  FROM comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')/(SELECT count(DISTINCT deviceid)  FROM comzs  where dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0' and dataTime <> firstLogin)");
    $dayTotalTime = mysql_fetch_array($dayTotalTime_query);

    //今日均消费金钱 DayUsedMoney 
    $dayUsedMoney_query = mysql_query("select (SELECT sum(cashSpendWeapons+cashSpendBullets)  FROM  comzs   where dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')/('$dayActivePesonrNum[0]')");
    $dayUsedMoney = mysql_fetch_array($dayUsedMoney_query);

    //weekPayPesonrNum 周付费用户数 SELECT count( DISTINCT deviceid )  
    $weekPayPesonrNum_query = mysql_query("SELECT  DISTINCT deviceid FROM `comzs` WHERE iap_Buy_Count_0 >0 and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' union 

        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_1 >0 and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_2 >0  and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_3 >0 and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_4 >0 and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_5 >0 and  isJailbreak = '0' and dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' ");
    $weekPayPesonrNum = mysql_num_rows($weekPayPesonrNum_query);
    //dayIAPGetMoney  今日人均 IAP 获得金钱
    $dayIAPGetMoney_query = mysql_query("select (select sum(cashIap) from comzs where dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')/('$dayActivePesonrNum[0]')");
    $dayIAPGetMoney = mysql_fetch_array($dayIAPGetMoney_query);
    //avgDayMoney  今日人均获得金钱
    $avgDayMoney_query = mysql_query("select (SELECT sum(cashLoot)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')/(SELECT count(deviceid)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')");
    $avgDayMoney = mysql_fetch_array($avgDayMoney_query);
    
    //dayNowMoney  今日人均现有金钱
    $dayNowMoney_query = mysql_query("select (SELECT sum(CashCurrent)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0')/(SELECT count(deviceid)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0' )");
    $dayNowMoney = mysql_fetch_array($dayNowMoney_query);

/*
    //最后退出 10界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen10Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 10  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen10Num = mysql_fetch_array($Lastloginscreen10Num_query);

        //最后退出 21界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen21Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 21  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen21Num = mysql_fetch_array($Lastloginscreen21Num_query);

        //最后退出 22界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen22Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 22  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen22Num = mysql_fetch_array($Lastloginscreen22Num_query);
        //最后退出 23界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen23Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 23  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen23Num = mysql_fetch_array($Lastloginscreen23Num_query);
        //最后退出 24界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen24m_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 24  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen24Num = mysql_fetch_array($Lastloginscreen24m_query);
        //最后退出 31界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen31Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 31  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen31Num = mysql_fetch_array($Lastloginscreen31Num_query);
        //最后退出 41界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen41Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 41  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen41Num = mysql_fetch_array($Lastloginscreen41Num_query);
        //最后退出 42界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen42Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 42  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen42Num = mysql_fetch_array($Lastloginscreen42Num_query);
        //最后退出 50界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen50Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 50  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen50Num = mysql_fetch_array($Lastloginscreen50Num_query);
        //最后退出 60界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen60Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 60  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen60Num = mysql_fetch_array($Lastloginscreen60Num_query);
        //最后退出 71界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen71Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 71  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen71Num = mysql_fetch_array($Lastloginscreen71Num_query);
        //最后退出 72界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen72Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 72  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen72Num = mysql_fetch_array($Lastloginscreen72Num_query);
        //最后退出 73界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen73Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 73  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen73Num = mysql_fetch_array($Lastloginscreen73Num_query);
        //最后退出 80界面 人数统计 Lastloginscreen10Num
    $Lastloginscreen80Num_query = mysql_query("SELECT count(distinct deviceid) FROM comzs where isJailbreak = '0' and UILastId = 80  and dataTime ='$everylogdate[dataTime]'");
    $Lastloginscreen80Num = mysql_fetch_array($Lastloginscreen80Num_query);
*/
/*
 
    // p1等级分布 (1,2,....)
    $dataTime = array('1' => array($p1dataTime1Count, $dataTime1), array($p1dataTime2Count, $dataTime2), array($p1dataTime3Count, $dataTime3), array($p1dataTime4Count, $dataTime4), array($p1dataTime5Count, $dataTime5), array($p1dataTime6Count, $dataTime6), array($p1dataTime7Count, $dataTime7), array($p1dataTime8Count, $dataTime8), array($p1dataTime9Count, $dataTime9), array($p1dataTime10Count, $dataTime10), array($p1dataTime11Count, $dataTime11), array($p1dataTime12Count, $dataTime12), array($p1dataTime13Count, $dataTime13), array($p1dataTime14Count, $dataTime14), array($p1dataTime15Count, $dataTime15), array($p1dataTime16Count, $dataTime16), array($p1dataTime17Count, $dataTime17), array($p1dataTime18Count, $dataTime18), array($p1dataTime19Count, $dataTime19), array($p1dataTime20Count, $dataTime20), array($p1dataTime21Count, $dataTime21));
    // $dataTime1[] = 
    $dataTime1_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =1
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =1
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime1_a = mysql_fetch_array($dataTime1_query);
    $dataTime1 = $dataTime1_a[0];
    $p1dataTime1Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =1
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =1
AND a.isJailbreak = '0'
");
    $p1dataTime1Count_a = mysql_fetch_array($p1dataTime1Count_query);
    $p1dataTime1Count = $p1dataTime1Count_a[0];
    $dataTime2_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =2
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =2
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime2_a = mysql_fetch_array($dataTime2_query);
    $dataTime2 = $dataTime2_a[0];
    $p1dataTime2Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =2
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =2
AND a.isJailbreak = '0'");
    $p1dataTime2Count_a = mysql_fetch_array($p1dataTime2Count_query);
    $p1dataTime2Count = $p1dataTime2Count_a[0];
    $dataTime3_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =3
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =3
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime3_a = mysql_fetch_array($dataTime3_query);
    $dataTime3 = $dataTime3_a[0];
    $p1dataTime3Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =3
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =3
AND a.isJailbreak = '0'");
    $p1dataTime3Count_a = mysql_fetch_array($p1dataTime3Count_query);
    $p1dataTime3Count = $p1dataTime3Count_a[0];
    $dataTime4_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =4
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =4
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime4_a = mysql_fetch_array($dataTime4_query);
    $dataTime4 = $dataTime4_a[0];
    $p1dataTime4Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =4
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =4
AND a.isJailbreak = '0'");
    $p1dataTime4Count_a = mysql_fetch_array($p1dataTime4Count_query);
    $p1dataTime4Count = $p1dataTime4Count_a[0];
    $dataTime5_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =5
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =5
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime5_a = mysql_fetch_array($dataTime5_query);
    $dataTime5 = $dataTime5_a[0];
    $p1dataTime5Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =5
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =5
AND a.isJailbreak = '0'");
    $p1dataTime5Count_a = mysql_fetch_array($p1dataTime5Count_query);
    $p1dataTime5Count = $p1dataTime5Count_a[0];
    $dataTime6_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =6
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =6
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime6_a = mysql_fetch_array($dataTime6_query);
    $dataTime6 = $dataTime6_a[0];
    $p1dataTime6Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =6
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =6
AND a.isJailbreak = '0'");
    $p1dataTime6Count_a = mysql_fetch_array($p1dataTime6Count_query);
    $p1dataTime6Count = $p1dataTime6Count_a[0];
    $dataTime7_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =7
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =7
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime7_a = mysql_fetch_array($dataTime7_query);
    $dataTime7 = $dataTime7_a[0];
    $p1dataTime7Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =7
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =7
AND a.isJailbreak = '0'");
    $p1dataTime7Count_a = mysql_fetch_array($p1dataTime7Count_query);
    $p1dataTime7Count = $p1dataTime7Count_a[0];
    $dataTime8_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =8
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =8
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime8_a = mysql_fetch_array($dataTime8_query);
    $dataTime8 = $dataTime8_a[0];
    $p1dataTime8Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max(id)
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =8
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime(a.dataTime)
AND a.Level =8
AND a.isJailbreak = '0'");
    $p1dataTime8Count_a = mysql_fetch_array($p1dataTime8Count_query);
    $p1dataTime8Count = $p1dataTime8Count_a[0];
    $dataTime9_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =9
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =9
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime9_a = mysql_fetch_array($dataTime9_query);
    $dataTime9 = $dataTime9_a[0];
    $p1dataTime9Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =9
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =9
AND a.isJailbreak = '0'");
    $p1dataTime9Count_a = mysql_fetch_array($p1dataTime9Count_query);
    $p1dataTime9Count = $p1dataTime9Count_a[0];
    $dataTime10_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =10
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =10
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime10_a = mysql_fetch_array($dataTime10_query);
    $dataTime10 = $dataTime10_a[0];
    $p1dataTime10Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level =10
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level =10
AND a.isJailbreak = '0'");
    $p1dataTime10Count_a = mysql_fetch_array($p1dataTime10Count_query);
    $p1dataTime10Count = $p1dataTime10Count_a[0];
    $dataTime11_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 11 and 15
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 11 and 15
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')
");
    $dataTime11_a = mysql_fetch_array($dataTime11_query);
    $dataTime11 = $dataTime11_a[0];
    $p1dataTime11Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 11 and 15
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 11 and 15
AND a.isJailbreak = '0'");
    $p1dataTime11Count_a = mysql_fetch_array($p1dataTime11Count_query);
    $p1dataTime11Count = $p1dataTime11Count_a[0];
    $dataTime12_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 16 and 20
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 16 and 20
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%'
)");
    $dataTime12_a = mysql_fetch_array($dataTime12_query);
    $dataTime12 = $dataTime12_a[0];
    $p1dataTime12Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 16 and 20
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 16 and 20
AND a.isJailbreak = '0'");
    $p1dataTime12Count_a = mysql_fetch_array($p1dataTime12Count_query);
    $p1dataTime12Count = $p1dataTime12Count_a[0];
    $dataTime13_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 21 and 25
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 21 and 25
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime13_a = mysql_fetch_array($dataTime13_query);
    $dataTime13 = $dataTime13_a[0];
    $p1dataTime13Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 21 and 25
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 21 and 25
AND a.isJailbreak = '0'");
    $p1dataTime13Count_a = mysql_fetch_array($p1dataTime13Count_query);
    $p1dataTime13Count = $p1dataTime13Count_a[0];
    $dataTime14_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 26 and 30
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 26 and 30
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime14_a = mysql_fetch_array($dataTime14_query);
    $dataTime14 = $dataTime14_a[0];
    $p1dataTime14Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 26 and 30
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 26 and 30
AND a.isJailbreak = '0'");
    $p1dataTime14Count_a = mysql_fetch_array($p1dataTime14Count_query);
    $p1dataTime14Count = $p1dataTime14Count_a[0];
    $dataTime15_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 31 and 40
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 31 and 40
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime15_a = mysql_fetch_array($dataTime15_query);
    $dataTime15 = $dataTime15_a[0];
    $p1dataTime15Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 31 and 40
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 31 and 40
AND a.isJailbreak = '0'");
    $p1dataTime15Count_a = mysql_fetch_array($p1dataTime15Count_query);
    $p1dataTime15Count = $p1dataTime15Count_a[0];
    $dataTime16_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 41 and 50
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 41 and 50
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime16_a = mysql_fetch_array($dataTime16_query);
    $dataTime16 = $dataTime16_a[0];
    $p1dataTime16Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 41 and 50
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 41 and 50
AND a.isJailbreak = '0'");
    $p1dataTime16Count_a = mysql_fetch_array($p1dataTime16Count_query);
    $p1dataTime16Count = $p1dataTime16Count_a[0];
    $dataTime17_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 51 and 60
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 51 and 60
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime17_a = mysql_fetch_array($dataTime17_query);
    $dataTime17 = $dataTime17_a[0];
    $p1dataTime17Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 51 and 60
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 51 and 60
AND a.isJailbreak = '0'");
    $p1dataTime17Count_a = mysql_fetch_array($p1dataTime17Count_query);
    $p1dataTime17Count = $p1dataTime17Count_a[0];
    $dataTime18_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 61 and 70
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 61 and 70
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime18_a = mysql_fetch_array($dataTime18_query);
    $dataTime18 = $dataTime18_a[0];
    $p1dataTime18Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 61 and 70
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 61 and 70
AND a.isJailbreak = '0'");
    $p1dataTime18Count_a = mysql_fetch_array($p1dataTime18Count_query);
    $p1dataTime18Count = $p1dataTime18Count_a[0];
    $dataTime19_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 71 and 80
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 71 and 80
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime19_a = mysql_fetch_array($dataTime19_query);
    $dataTime19 = $dataTime19_a[0];
    $p1dataTime19Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 71 and 80
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 71 and 80
AND a.isJailbreak = '0'");
    $p1dataTime19Count_a = mysql_fetch_array($p1dataTime19Count_query);
    $p1dataTime19Count = $p1dataTime19Count_a[0];
    $dataTime20_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 81 and 90
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 81 and 90
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime20_a = mysql_fetch_array($dataTime20_query);
    $dataTime20 = $dataTime20_a[0];
    $p1dataTime20Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 81 and 90
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 81 and 90
AND a.isJailbreak = '0'");
    $p1dataTime20Count_a = mysql_fetch_array($p1dataTime20Count_query);
    $p1dataTime20Count = $p1dataTime20Count_a[0];
    $dataTime21_query = mysql_query("SELECT concat( (
(

SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 91 and 100
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 91 and 100
AND a.isJailbreak = '0' ) / (
SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.isJailbreak = '0' )
) *100, '%')");
    $dataTime21_a = mysql_fetch_array($dataTime21_query);
    $dataTime21 = $dataTime21_a[0];
    $p1dataTime21Count_query = mysql_query("SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE id = (
SELECT max( id )
FROM comzs
WHERE `deviceid` = a.`deviceid`
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( dataTime )
AND Level between 91 and 100
AND isJailbreak = '0' )
AND date_sub( '$everylogdate[dataTime]', INTERVAL 7
DAY ) <= dataTime( a.dataTime )
AND a.Level between 91 and 100
AND a.isJailbreak = '0'");
    $p1dataTime21Count_a = mysql_fetch_array($p1dataTime21Count_query);
    $p1dataTime21Count = $p1dataTime21Count_a[0];
    $Level = array(json_encode($dataTime));//等级分布  */

        //newPayPesonrNum  新增付费人数
    /*SELECT count( DISTINCT deviceid )
FROM comzs a
WHERE cashIap >0
AND dataTime = '$everylogdate[dataTime]'
AND isJailbreak = '0'
AND NOT
EXISTS (

SELECT DISTINCT deviceid
FROM comzs
WHERE cashIap >0
AND dataTime < '$everylogdate[dataTime]'
AND isJailbreak = '0'
AND a.deviceid = deviceid
)
*/
    $newPayPesonrNum_query = mysql_query("select A.deviceid  from (SELECT  DISTINCT deviceid FROM `comzs` WHERE iap_Buy_Count_0 >0  and 

        dataTime 

        = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY ) and  isJailbreak = '0'  union 

        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_1 >0 and dataTime = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY ) and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_2 >0 and dataTime = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY ) and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_3 >0 and dataTime = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY ) and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_4 >0 and dataTime = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY )  and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_5 >0 and dataTime = DATE_SUB( 

        '$everylogdate[dataTime]', INTERVAL 0
        DAY ) and  isJailbreak = '0')A left join (SELECT  DISTINCT deviceid FROM `comzs` WHERE 

        iap_Buy_Count_0 >0  and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY ) and  isJailbreak = '0'  union 

        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_1 >0 and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY ) and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_2 >0 and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY )  and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_3 >0 and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY ) and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_4 >0 and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY )  and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_5 >0 and dataTime
        BETWEEN DATE_SUB( '$everylogdate[dataTime]', INTERVAL 360
        DAY )
        AND DATE_SUB( '$everylogdate[dataTime]', INTERVAL 1
        DAY ) and  isJailbreak = '0' )B on A.deviceid =B.deviceid  where B.deviceid  is null");
    $newPayPesonrNum = mysql_num_rows($newPayPesonrNum_query);
    //今日付费次数 paytimes
    $paytimes_query = mysql_query("SELECT sum(iap_Buy_Count_0 + iap_Buy_Count_1 + iap_Buy_Count_2 + iap_Buy_Count_3 + iap_Buy_Count_4 +iap_Buy_Count_5)  FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and  isJailbreak = '0'");
    $paytimes = mysql_fetch_array($paytimes_query);
    //今日付费用户数 PayPesonrNum
    $PayPesonrNum_query = mysql_query("SELECT  DISTINCT deviceid FROM `comzs` WHERE iap_Buy_Count_0 >0  and dataTime = '$everylogdate[dataTime]' and  isJailbreak = '0'  union 
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_1 >0 and dataTime = '$everylogdate[dataTime]' and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_2 >0 and dataTime = '$everylogdate[dataTime]'  and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_3 >0 and dataTime = '$everylogdate[dataTime]' and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_4 >0 and dataTime = '$everylogdate[dataTime]'  and  isJailbreak = '0' union
        SELECT  DISTINCT deviceid FROM `comzs` WHERE  iap_Buy_Count_5 >0 and dataTime = '$everylogdate[dataTime]' and  isJailbreak = '0' ");
    $PayPesonrNum = mysql_num_rows($PayPesonrNum_query);

     $iap1_query = mysql_query(" SELECT sum(iap_Buy_Count_0) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0' ");
    $iap1 = mysql_fetch_array($iap1_query);
   /* }
      var_dump($iap1_to[0]);*/
    //iap2
    $iap2_query = mysql_query("SELECT sum(iap_Buy_Count_1) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0'");
    $iap2 = mysql_fetch_array($iap2_query);
    //iap3
    $iap3_query = mysql_query("SELECT sum(iap_Buy_Count_2) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0'");
    $iap3 = mysql_fetch_array($iap3_query);
    //iap4
    $iap4_query = mysql_query("SELECT sum(iap_Buy_Count_3) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0'");
    $iap4 = mysql_fetch_array($iap4_query);
    //iap5
    $iap5_query = mysql_query("SELECT sum(iap_Buy_Count_4) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0'");
    $iap5 = mysql_fetch_array($iap5_query);
     // iap6
     $iap6_query = mysql_query("SELECT sum(iap_Buy_Count_5) FROM  comzs  where  dataTime ='$everylogdate[dataTime]' and isJailbreak = '0'");
     $iap6 = mysql_fetch_array($iap6_query);

     //WeekNewPayPesonrNum 过去7日内新增注册用户数
     $WeekNewPayPesonrNum_query = mysql_query("SELECT count( DISTINCT deviceid )
        FROM comzs
        WHERE firstLogin
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0'");
     $WeekNewPayPesonrNum = mysql_fetch_array($WeekNewPayPesonrNum_query);
     //MonthLandTwicePesonrNum 过去30日内2次登录用户数
        $MonthLandTwicePesonrNum_query = mysql_query("SELECT DISTINCT deviceid, dataTime
        FROM comzs
        WHERE isJailbreak = '0'
        AND dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 30
        DAY )
        AND date_sub( '$everylogdate[dataTime]', INTERVAL 1
        DAY )
        GROUP BY deviceid
        HAVING count( 1 ) >1 ");
     $MonthLandTwicePesonrNum = mysql_num_rows($MonthLandTwicePesonrNum_query);
     //WeekPayRechargeNum 周付费用户充值笔数
             $WeekPayRechargeNum_query = mysql_query("SELECT sum(iap_Buy_Count_0  +iap_Buy_Count_1 + iap_Buy_Count_2  + iap_Buy_Count_3  + iap_Buy_Count_4  + iap_Buy_Count_5)
        FROM comzs
        WHERE dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0'
        ");
     $WeekPayRechargeNum = mysql_fetch_array($WeekPayRechargeNum_query);

    //dayRechargeNum  今日人均充值笔数
   $dayRechargeNum_query = mysql_query("select '$paytimes[0]'/'$PayPesonrNum'");
   $dayRechargeNum = mysql_fetch_array($dayRechargeNum_query);
   //weekPayARPU 周付费用户ARPU值 =周付费总额/周付费人数
    $weekPayARPU_query = mysql_query("SELECT (
        SELECT sum( iap_Buy_Count_0*99  +iap_Buy_Count_1 *499 + iap_Buy_Count_2 *999 + iap_Buy_Count_3 *1999 + iap_Buy_Count_4*4999  + iap_Buy_Count_5*9999)
        FROM comzs
        WHERE dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0'
        ) / (
        '$weekPayPesonrNum' )");

    $weekPayARPU = mysql_fetch_array($weekPayARPU_query); 
    
    //weekActiveARPU 周活跃用户ARPU值
    $weekActiveARPU_query = mysql_query("SELECT (
        SELECT sum(iap_Buy_Count_0*99  +iap_Buy_Count_1 *499 + iap_Buy_Count_2 *999 + iap_Buy_Count_3 *1999 + iap_Buy_Count_4*4999  + iap_Buy_Count_5*9999)
        FROM comzs
        WHERE dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0'
        ) / ($weekActivePesonrNum) ");
   $weekActiveARPU = mysql_fetch_array($weekActiveARPU_query);
   
       //weekLogARPU 周登陆用户ARPU值  = 周付费用户/周登陆人数(活跃用户+新用户)  
   $weekLogARPU_query = mysql_query("SELECT (
        SELECT sum( iap_Buy_Count_0*99  +iap_Buy_Count_1 *499 + iap_Buy_Count_2 *999 + iap_Buy_Count_3 *1999 + iap_Buy_Count_4*4999  + iap_Buy_Count_5*9999)
        FROM comzs
        WHERE dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0'
        ) / (
        SELECT count( DISTINCT deviceid )
        FROM comzs
        WHERE dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]'
        AND isJailbreak = '0' ) ");
      $weekLogARPU = mysql_fetch_array($weekLogARPU_query);
      //weekWastageRate  周活跃用户流失率 上周活跃用户在本周没有登陆过游戏的用户数，除以上周的活跃人数。
      $weekWastageRate_query = mysql_query("SELECT concat(round( (
        SELECT (
        SELECT count( a.deviceid )
        FROM weekActive a
        WHERE a.dataTime = date_sub('$everylogdate[dataTime]',interval 7 day)  
        AND a.deviceid NOT
        IN (
        SELECT DISTINCT deviceid
        FROM comzs
        WHERE isJailbreak = '0'
        AND dataTime
        BETWEEN date_sub('$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' )
        ) / (
        SELECT count( 1 )
        FROM weekActive
        WHERE dataTime = date_sub('$everylogdate[dataTime]',interval 7 day))
        ) *100,2), '%'
        )  ");
     $weekWastageRate = mysql_fetch_array($weekWastageRate_query); 
     //weekPayRate  周活跃用户付费率 周付费用户数除以周活跃人数
    //$weekPayRate_query = mysql_query("select '$weekPayPesonrNum[0]'/'$weekActivePesonrNum[0]'");
    $weekPayRate_query = mysql_query("SELECT concat(round( '$weekPayPesonrNum'/  '$weekActivePesonrNum' *100,2), '%' ) ");
    $weekPayRate = mysql_fetch_array($weekPayRate_query);
    //weekLogPayRate周登陆用户付费率 周付费用户数除以周登陆人数
    $weekLogPayRate_query = mysql_query("SELECT concat(round( '$weekPayPesonrNum'/  '$weekOneLandPesonrNum' *100,2), '%' ) ");
    $weekLogPayRate = mysql_fetch_array($weekLogPayRate_query);
       //weekPayWastageRate  周付费用户流失率 上周有付费行为而本周7天未登陆的用户数除以上周的付费用户数  
    $weekPayWastageRate_query = mysql_query("SELECT concat( round((
        SELECT (
        SELECT count( a.deviceid )
        FROM weekPay a
        WHERE a.dataTime = date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND a.deviceid NOT
        IN (

        SELECT DISTINCT deviceid
        FROM comzs
        WHERE isJailbreak = '0'
        AND dataTime
        BETWEEN date_sub( '$everylogdate[dataTime]', INTERVAL 7
        DAY )
        AND '$everylogdate[dataTime]' )
        ) / (
        SELECT count( 1 )
        FROM weekPay
        WHERE dataTime =  date_sub('$everylogdate[dataTime]',interval 7 day) )
        ) *100,2), '%'
        ) ");
     $weekPayWastageRate = mysql_fetch_array($weekPayWastageRate_query);
     //周付费用户人均充值笔数
     $weekPayPesonrTime_query = mysql_query("SELECT '$WeekPayRechargeNum[0]'/'$weekPayPesonrNum'");
     $weekPayPesonrTime = mysql_fetch_array($weekPayPesonrTime_query);

   
 $sql="REPLACE INTO report_nojailbreak (logdate,loginPersonNum,activePesonrNum,activePesonrTime,totalDayTotalTime,
                                        totalDayGetMoney,totalDayRecharge,totalDayUsedMoney,dayLoginPersonNum,
                                        totalDayNewusers,dayActivePesonrNum,dayActivePesonrTime,weekActivePesonrNum,weekLoyalPesonrNum,weekCorePesonrNum,
                                        hirePesonrNum,dayTotalTime,dayUsedMoney,weekPayPesonrNum,dayIAPGetMoney,
                                        avgDayMoney,dayNowMoney,
                                        Lastloginscreen10Num,Lastloginscreen21Num,Lastloginscreen22Num,Lastloginscreen23Num,Lastloginscreen24Num,
                                        Lastloginscreen31Num,Lastloginscreen41Num,Lastloginscreen42Num,Lastloginscreen50Num,Lastloginscreen60Num,
                                        Lastloginscreen71Num,Lastloginscreen72Num,Lastloginscreen73Num,Lastloginscreen80Num,
                                        weekPayARPU,weekActiveARPU,weekLogARPU,weekWastageRate,weekPayRate,weekLogPayRate,weekPayWastageRate,
                                        weekPayPesonrTime,playerLevel,newPayPesonrNum,paytimes,PayPesonrNum,
                                        iap1,iap2,iap3,iap4,iap5,iap6,iap7,iap8,iap9,iap10,iap11,iap12,iap13,iap14,iap15,iap16,totalDayPlayTime,
                                        weekOneLandPesonrNum,WeekNewPayPesonrNum,MonthLandTwicePesonrNum,WeekPayRechargeNum,dayRechargeNum) 
                  VALUES('$everylogdate[dataTime]','$loginPersonNum[0]','$activePesonrNum[0]','$activePesonrTime[0]','$totalDayTotalTime[0]',
                         '$totalDayGetMoney[0]','$totalDayRecharge[0]','$totalDayUsedMoney[0]','$dayLoginPersonNum[0]',
                         '$totalDayNewusers[0]','$dayActivePesonrNum[0]','$dayActivePesonrTime[0]','$weekActivePesonrNum','$weekLoyalPesonrNum','$weekCorePesonrNum',
                          '$hirePesonrNum[0]','$dayTotalTime[0]','$dayUsedMoney[0]','$weekPayPesonrNum','$dayIAPGetMoney[0]',
                          '$avgDayMoney[0]','$dayNowMoney[0]',
                          '$Lastloginscreen10Num[0]','$Lastloginscreen21Num[0]','$Lastloginscreen22Num[0]','$Lastloginscreen23Num[0]','$Lastloginscreen24Num[0]',
                          '$Lastloginscreen31Num[0]','$Lastloginscreen41Num[0]','$Lastloginscreen42Num[0]','$Lastloginscreen50Num[0]','$Lastloginscreen60Num[0]',
                          '$Lastloginscreen71Num[0]','$Lastloginscreen72Num[0]','$Lastloginscreen73Num[0]','$Lastloginscreen80Num[0]',
                          '$weekPayARPU[0]','$weekActiveARPU[0]','$weekLogARPU[0]','$weekWastageRate[0]','$weekPayRate[0]','$weekLogPayRate[0]','$weekPayWastageRate[0]',
                          '$weekPayPesonrTime[0]','$Level[0]','$newPayPesonrNum','$paytimes[0]','$PayPesonrNum',
                          '$iap1[0]','$iap2[0]','$iap3[0]','$iap4[0]','$iap5[0]','$iap6[0]','$iap7[0]','$iap8[0]','$iap9[0]','$iap10[0]','$iap11[0]','$iap12[0]','$iap13[0]','$iap14[0]','$iap15[0]','$iap16[0]',
                          '$totalTodayGameTime[0]',
                          '$weekOneLandPesonrNum','$WeekNewPayPesonrNum[0]','$MonthLandTwicePesonrNum','$WeekPayRechargeNum[0]','$dayRechargeNum[0]')";
$query= @mysql_query($sql,$connection) or die(mysql_error());  

}
?>
